from django.db import models
from datetime import datetime
from users.models import *
from courses.models import *
# Create your models here.
class UserAsk(models.Model):
    name = models.CharField(max_length=50,verbose_name='姓名')
    mobile = models.CharField(max_length=11,verbose_name='手机')
    course_name = models.CharField(max_length=100,verbose_name='课程名')
    add_time = models.DateTimeField(default=datetime.now,verbose_name='添加时间')
    class Meta:
        verbose_name = '用户咨询'
        verbose_name_plural = verbose_name
    def __str__(self):
        return self.name

class CourseComment(models.Model):
    user = models.ForeignKey(UserProfile,verbose_name="用户")
    course = models.ForeignKey(Course,verbose_name='课程')
    comment = models.CharField(max_length=300,verbose_name='评论')
    add_time = models.DateTimeField(default=datetime.now, verbose_name='添加时间')
    class Meta:
        verbose_name = '课程评论'
        verbose_name_plural = verbose_name
    def __str__(self):
        return self.comment

class UserFavorite(models.Model):
    user = models.ForeignKey(UserProfile,verbose_name="用户")
    fav_id = models.IntegerField(default=0,verbose_name='数据id')
    fav_type = models.IntegerField(choices=((1,'课程'),(2,'课程机构'),(3,'讲师')),default=1,verbose_name='收藏类型')
    add_time = models.DateTimeField(default=datetime.now, verbose_name='添加时间')
    class Meta:
        verbose_name = '课程/机构/讲师收藏'
        verbose_name_plural = verbose_name
    def __str__(self):
        return self.fav_id

class UserMessage(models.Model):
    user = models.IntegerField(default=0,verbose_name='接收用户')
    message = models.CharField(max_length=500,verbose_name='消息内容')
    has_read = models.BooleanField(default=False,verbose_name='是否已读')
    add_time = models.DateTimeField(default=datetime.now, verbose_name='添加时间')
    class Meta:
        verbose_name = '用户消息'
        verbose_name_plural = verbose_name
    def __str__(self):
        return self.message

class UserCourse(models.Model):
    user = models.ForeignKey(UserProfile, verbose_name="用户")
    course = models.ForeignKey(Course, verbose_name='课程')
    add_time = models.DateTimeField(default=datetime.now, verbose_name='添加时间')
    class Meta:
        verbose_name = '用户课程'
        verbose_name_plural = verbose_name
    def __str__(self):
        return self.course.name